This model dimension represents company reporting periods and is based on the IFS Cloud dimension DIM_RPD_COMPANY_PERIOD. All models that refer to this dimension will have the attributes and hierarchies as described below. Reporting periods are defined per "product" area, meaning that e.g. the Sales model is using periods related to one specific reporting period identity. The identity that applies is defined via configurations.
Natural keys in core dimension: RPD_ID, COMPANY, REPORTING_DATE
| Attribute | Description (where applicable) |
| Company | The company identity. |
| Company-Date | Defined as the COMPANY + ' - ' + REPORTING DATE |
| Reporting Date | The REPORTING_DATE without a time stamp. |
| Reporting Period Descr | The description of the reporting period associated with Company and Reporting Date (RPD_ID_DESCRIPTION) |
| Reporting Period No | The reporting period (number) associated with Company and Reporting Date (RPD_PERIOD) |
| Reporting Year | The reporting year associated with Company and Reporting Date (RPD_YEAR) |
| Reporting YearPeriod | The reporting year (RPD_YEAR) and period (RPD_PERIOD), associated with Company and Reporting Date, concatenated as a number in the format YYYYMM |
| Hierarchy | Level |
| RepPeriodFHy | |
| Company | |
| Reporting Year | |
| Reporting Period No | |
| Reporting Date | |
| Company-Date | |
| RepPeriodSHy | |
| Company | |
| Reporting Year | |
| Reporting Period No |
| Model Name |
| Procurement |
| Sales |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| REPORTING PERIOD | DIM_REPORTING_PERIOD_ | DIM_RDP_COMPANY_PERIOD_BI | DIM_RDP_COMPANY_PERIOD | On Line |